OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » what connect string?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what connect string? [message #67443]

Tue, 27 July 2004 23:39

nasrin
Messages: 2
Registered: July 2004

Junior Member

Hi
I have oracle 8.1.7 on Linux RedHat 7.3.
I need to connect to my oracle database via ODBC.
I use an oracle-odbc driver from easysoft and unixODBC.
the name of database is O817DB.

before starting to connect by ODBC I tried this:
sqlplus myuser/mypass@smsc.sms.shrif.edu:1521:O817DB

but I get this error message:
ORA-06401: NETCMN: invalid driver designator

I know that The login (connect) string contains an invalid driver designator.but I don't know how to write the true connection string.
this is the tnsnames.ora file:
ORACLE.sms.sharif.edu =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.40)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = 1.1.1.40)
    )
)

INST1_HTTP.sms.sharif.edu =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = smsc.sms.sharif.edu)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = smsc.sms.sharif.edu)
      (PRESENTATION = http://admin)
    )
)

EXTPROC_CONNECTION_DATA.sms.sharif.edu =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
)

please guide me how to fix this error.
Thanks

Report message to a moderator

Re: what connect string? [message #67457 is a reply to message #67443]

Fri, 06 August 2004 05:32

Vincenzo
Messages: 6
Registered: July 2004

Junior Member

you should have install oracle client. try this:

sqlplus youruser@ORACLE.sms.sharif.edu/yourpassword

delete caracter � into tnsnames.ora
bye

Report message to a moderator

Previous Topic:	ORA-1256:TNS: protocol adapter error, Plz help me
Next Topic:	delete listener.log

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 29 04:27:24 CDT 2026